How to: Add data labels to a data series in a chart.
Solution:
Select the data series to label, select the 'Insert' menu and select 'Data Labels...'.
To add data labels for a data series:
1) To select the chart where the new data labels should appear:
a) If the chart is embedded on the worksheet, double-click on the chart. (A striped border with handles appears around the chart.)
b) If the chart is on a separate chart sheet, click the tab for the chart sheet and double-click on the chart. (A striped border with handles appears around the chart.)
2) Select the data series to label. (Handles appear across the selected data series.)
3) Select the 'Insert' menu and select 'Data Labels...'. (The Data Labels dialog box appears.)
Data Labels dialog box
NOTE: The chart type associated with the selected data point determines the type of label that can be inserted.
4) Select the radio button for the desired type of label from the 'Data Labels' group.
5) Click 'OK'.
